<?php
		require(dirname(dirname(dirname(dirname(dirname(__FILE__)))))."/app/include/dbbackup/inc/header.php");
	ExcuteSQL("DROP TABLE IF EXISTS `phpyun_comclass`;");
CreateTable("CREATE TABLE `phpyun_comclass` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `keyid` int(11) NOT NULL,
  `name` varchar(50) NOT NULL,
  `variable` varchar(50) DEFAULT NULL,
  `sort` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=153 DEFAULT CHARSET=utf8");
ExcuteSQL("insert into `phpyun_comclass` values('112','39','未婚',NULL,'2');");
ExcuteSQL("insert into `phpyun_comclass` values('75','0','企业反馈类型','job_message','0');");
ExcuteSQL("insert into `phpyun_comclass` values('10','0','工作经验','job_exp','0');");
ExcuteSQL("insert into `phpyun_comclass` values('12','10','应届毕业生','','2');");
ExcuteSQL("insert into `phpyun_comclass` values('13','10','1年以上','','3');");
ExcuteSQL("insert into `phpyun_comclass` values('14','10','2年以上','','4');");
ExcuteSQL("insert into `phpyun_comclass` values('15','10','3年以上','','5');");
ExcuteSQL("insert into `phpyun_comclass` values('16','10','5年以上','','6');");
ExcuteSQL("insert into `phpyun_comclass` values('17','10','8年以上','','7');");
ExcuteSQL("insert into `phpyun_comclass` values('18','10','10年以上','','8');");
ExcuteSQL("insert into `phpyun_comclass` values('19','0','企业性质','job_pr','0');");
ExcuteSQL("insert into `phpyun_comclass` values('20','19','外资企业','','0');");
ExcuteSQL("insert into `phpyun_comclass` values('21','19','合资企业','','1');");
ExcuteSQL("insert into `phpyun_comclass` values('23','19','民营企业','','3');");
ExcuteSQL("insert into `phpyun_comclass` values('24','19','股份制企业','','4');");
ExcuteSQL("insert into `phpyun_comclass` values('25','19','集体企业','','5');");
ExcuteSQL("insert into `phpyun_comclass` values('26','0','企业规模','job_mun','0');");
ExcuteSQL("insert into `phpyun_comclass` values('27','26','10人以下','','0');");
ExcuteSQL("insert into `phpyun_comclass` values('28','26','10-50人','','1');");
ExcuteSQL("insert into `phpyun_comclass` values('29','26','50-200人','','2');");
ExcuteSQL("insert into `phpyun_comclass` values('30','26','200-500人','','3');");
ExcuteSQL("insert into `phpyun_comclass` values('31','26','500-1000人','','4');");
ExcuteSQL("insert into `phpyun_comclass` values('32','26','1000人以上','','5');");
ExcuteSQL("insert into `phpyun_comclass` values('33','0','招聘人数','job_number','0');");
ExcuteSQL("insert into `phpyun_comclass` values('34','0','薪水待遇','job_salary','0');");
ExcuteSQL("insert into `phpyun_comclass` values('36','0','到岗时间','job_report','0');");
ExcuteSQL("insert into `phpyun_comclass` values('38','0','教育程度','job_edu','0');");
ExcuteSQL("insert into `phpyun_comclass` values('39','0','婚姻状况','job_marriage','0');");
ExcuteSQL("insert into `phpyun_comclass` values('40','33','若干','','0');");
ExcuteSQL("insert into `phpyun_comclass` values('41','33','1-2人','','1');");
ExcuteSQL("insert into `phpyun_comclass` values('42','33','3-4人','','2');");
ExcuteSQL("insert into `phpyun_comclass` values('43','33','5-6人','','3');");
ExcuteSQL("insert into `phpyun_comclass` values('44','33','7-8人','','4');");
ExcuteSQL("insert into `phpyun_comclass` values('45','33','9-10人','','5');");
ExcuteSQL("insert into `phpyun_comclass` values('46','34','面议','','1');");
ExcuteSQL("insert into `phpyun_comclass` values('47','34','1000以下','','2');");
ExcuteSQL("insert into `phpyun_comclass` values('48','34','1000 - 1999','','4');");
ExcuteSQL("insert into `phpyun_comclass` values('49','34','3000 - 4499','','5');");
ExcuteSQL("insert into `phpyun_comclass` values('50','34','4500 - 5999','','5');");
ExcuteSQL("insert into `phpyun_comclass` values('51','34','6000 - 7999','','6');");
ExcuteSQL("insert into `phpyun_comclass` values('52','34','8000 - 8999','','7');");
ExcuteSQL("insert into `phpyun_comclass` values('53','34','10000及以上','','9');");
ExcuteSQL("insert into `phpyun_comclass` values('54','36','不限','','0');");
ExcuteSQL("insert into `phpyun_comclass` values('57','36','1周以内','','1');");
ExcuteSQL("insert into `phpyun_comclass` values('58','36','2周以内','','2');");
ExcuteSQL("insert into `phpyun_comclass` values('59','36','3周以内','','3');");
ExcuteSQL("insert into `phpyun_comclass` values('60','36','1个月之内','','4');");
ExcuteSQL("insert into `phpyun_comclass` values('65','38','不限','','0');");
ExcuteSQL("insert into `phpyun_comclass` values('66','38','高中','','1');");
ExcuteSQL("insert into `phpyun_comclass` values('67','38','中专','','2');");
ExcuteSQL("insert into `phpyun_comclass` values('68','38','大专','','3');");
ExcuteSQL("insert into `phpyun_comclass` values('69','38','本科','','4');");
ExcuteSQL("insert into `phpyun_comclass` values('70','38','硕士','','5');");
ExcuteSQL("insert into `phpyun_comclass` values('71','38','博士','','6');");
ExcuteSQL("insert into `phpyun_comclass` values('72','39','不限','','0');");
ExcuteSQL("insert into `phpyun_comclass` values('73','39','已婚','','1');");
ExcuteSQL("insert into `phpyun_comclass` values('76','75','建议','','1');");
ExcuteSQL("insert into `phpyun_comclass` values('77','75','咨询','','1');");
ExcuteSQL("insert into `phpyun_comclass` values('78','75','购买','','1');");
ExcuteSQL("insert into `phpyun_comclass` values('79','19','上市公司','','6');");
ExcuteSQL("insert into `phpyun_comclass` values('80','19','国家机关','','7');");
ExcuteSQL("insert into `phpyun_comclass` values('81','19','事业单位','','8');");
ExcuteSQL("insert into `phpyun_comclass` values('82','19','其他','','9');");
ExcuteSQL("insert into `phpyun_comclass` values('83','34','2000 - 2999','','3');");
ExcuteSQL("insert into `phpyun_comclass` values('84','0','年龄要求','job_age',NULL);");
ExcuteSQL("insert into `phpyun_comclass` values('85','84','18-25岁',NULL,'2');");
ExcuteSQL("insert into `phpyun_comclass` values('86','84','35岁以下',NULL,'3');");
ExcuteSQL("insert into `phpyun_comclass` values('87','84','35岁以上',NULL,'4');");
ExcuteSQL("insert into `phpyun_comclass` values('88','84','不限','','1');");
ExcuteSQL("insert into `phpyun_comclass` values('89','0','福利待遇','job_welfare',NULL);");
ExcuteSQL("insert into `phpyun_comclass` values('90','89','三险一金',NULL,'0');");
ExcuteSQL("insert into `phpyun_comclass` values('91','89','五险一金',NULL,'0');");
ExcuteSQL("insert into `phpyun_comclass` values('92','89','包吃住',NULL,'0');");
ExcuteSQL("insert into `phpyun_comclass` values('93','89','综合补贴',NULL,'0');");
ExcuteSQL("insert into `phpyun_comclass` values('94','89','年终奖金',NULL,'0');");
ExcuteSQL("insert into `phpyun_comclass` values('95','89','奖励计划',NULL,'0');");
ExcuteSQL("insert into `phpyun_comclass` values('96','89','销售奖金',NULL,'0');");
ExcuteSQL("insert into `phpyun_comclass` values('97','89','休假制度',NULL,'0');");
ExcuteSQL("insert into `phpyun_comclass` values('98','89','法定节假日',NULL,'0');");
ExcuteSQL("insert into `phpyun_comclass` values('99','0','语言要求','job_lang',NULL);");
ExcuteSQL("insert into `phpyun_comclass` values('100','99','普通话一级',NULL,'0');");
ExcuteSQL("insert into `phpyun_comclass` values('101','99','普通话二级',NULL,'0');");
ExcuteSQL("insert into `phpyun_comclass` values('102','99','普通话三级',NULL,'0');");
ExcuteSQL("insert into `phpyun_comclass` values('103','99','英语',NULL,'10');");
ExcuteSQL("insert into `phpyun_comclass` values('104','99','韩语',NULL,'0');");
ExcuteSQL("insert into `phpyun_comclass` values('105','99','德语',NULL,'0');");
ExcuteSQL("insert into `phpyun_comclass` values('106','99','法语',NULL,'0');");
ExcuteSQL("insert into `phpyun_comclass` values('107','99','西班牙语',NULL,'0');");
ExcuteSQL("insert into `phpyun_comclass` values('108','99','粤语',NULL,'0');");
ExcuteSQL("insert into `phpyun_comclass` values('109','99','闽南语',NULL,'0');");
ExcuteSQL("insert into `phpyun_comclass` values('110','99','上海话',NULL,'0');");
ExcuteSQL("insert into `phpyun_comclass` values('127','10','不限',NULL,'1');");
ExcuteSQL("insert into `phpyun_comclass` values('133','0','体验时间','job_etime','0');");
ExcuteSQL("insert into `phpyun_comclass` values('134','133','1-2天',NULL,'1');");
ExcuteSQL("insert into `phpyun_comclass` values('146','0','面试评价','job_tags',NULL);");
ExcuteSQL("insert into `phpyun_comclass` values('149','146','面试效率高',NULL,NULL);");
ExcuteSQL("insert into `phpyun_comclass` values('148','146','面试官态度冰冷',NULL,NULL);");
ExcuteSQL("insert into `phpyun_comclass` values('147','146','面试官nice',NULL,NULL);");
ExcuteSQL("insert into `phpyun_comclass` values('150','146','薪资与描述不符',NULL,NULL);");
ExcuteSQL("insert into `phpyun_comclass` values('151','146','企业环境不错',NULL,NULL);");
ExcuteSQL("insert into `phpyun_comclass` values('152','146','福利待遇好',NULL,NULL);");

		require(dirname(dirname(dirname(dirname(dirname(__FILE__)))))."/app/include/dbbackup/inc/footer.php");
	?>